| |
203 Search Results Found |
| 1 |
Forum: Server Administration «»
Posted on: Tue, 12 February 2019 08:34 «»
By: wtolentino
Re: How To Get the username that is currently Proxy To
…so much saw some that might help. then found the dba_audit_trail might help with the use of column action_name = 'PROXY AUTHENTICATION ONLY'. from that table there is a column sessionid where can I link this column to other tables that might help me get …
|
| 2 |
Forum: Forms «»
Posted on: Thu, 30 August 2018 01:53 «»
By: glmjoy
reoprt calling from form 11g
…all,
I have write this code on when button pressed it was working but now it is not working.
PROCEDURE Print_Report IS
MCUR_ITM VARCHAR2(40) := :SYSTEM.CURSOR_ITEM;
mpara varchar2(20) := :REPORTID;
server_name varchar2(100) := :…
|
| 3 |
Forum: JDeveloper, Java & XML «»
Posted on: Tue, 20 February 2018 12:47 «»
By: CMcKinstry
Re: Using IDE Database Connections in Java code
…Thanks, that doesn't use the named database connection (testConnection). I'd still have to use the JDBC string along with username and password.
E.g.:
Note:
The login variables have been set to null to secure the application. At this point in the …
|
| 4 |
Forum: Server Utilities «»
Posted on: Fri, 08 December 2017 12:18 «»
By: rocioperezn
loading data from twitter with sqlldr
…all,
I have some problems loading a twitter data from a csv, with some multiline records. I have 4 columns id_tweet,text,created_at, username .
When text is enclosed by " the register is multiline or has comas inside, I show you 3 examples, …
|
| 5 |
Forum: Server Utilities «»
Posted on: Tue, 29 August 2017 10:59 «»
By: BlackSwan
Re: IMP-00010: not a valid export file, header failed verification
…>i think it was created by exp
You think wrongly.
exp does NOT have any DIRECTORY= parameter
[oracle@vbgeneric ~]$ exp help=yes
Export: Release 12.2.0.1.0 - Production on Tue Aug 29 11:57:27 2017
Copyright (c) 1982, 2017, Oracle and/or …
|
| 6 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Mon, 02 January 2017 06:58 «»
By: apexmahfuj
Hide schema name,username and password from url
…Hi,
I have called a rdf report (10g) from an apex page by passing three parameters and its working.
My report runs without no error.
But what have I found that the whole information such as schema name,user_name,password are showing in the path…
|
| 7 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Sun, 29 March 2015 11:28 «»
By: Michel Cadot
Re: Setting up Pro*C Pre compiler in Windows
…
First refer to Pro*C/C++ Programmer's Guide
Then there is nothing special to do.
Just be sure that ORACLE_HOME is set and PATH contains %ORACLE_HOME%\lib library.
Also add %OracleHome%\precomp\public in your include path.
Then the Pro*C call is …
|
| 8 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 04 March 2015 12:04 «»
By: sachinj
Writing a Hierarchical Query without using the connect by prior
…
--Table Creation Script
CREATE TABLE USERS
(
USERID INTEGER NOT NULL,
USERNAME VARCHAR2(255 BYTE) NOT NULL,
FULLNAME VARCHAR2(255 BYTE) NOT NULL,
USER_GROUP…
|
| 9 |
Forum: Reports & Discoverer «»
Posted on: Thu, 22 January 2015 02:55 «»
By: nickron
Re: Error while converting Reports from rdf to rep
Example----
rwconverter.sh userid=username/pw@db batch=yes source=paysliptest.rdf stype=rdffile dtype=repfile overwrite=yes compile_all=yes
|
| 10 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 September 2014 10:55 «»
By: cookiemonster
Re: Help with pre 9i Join to ANSI standard
…Ok, So Here's the issues:
1) Those brackets don't actually do anything useful, so you should just lose them.
2) You're mixing join styles - if you're using ANSI joins you should use them for all tables, so there should be an inner join for t1 and t2 …
|
| 11 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 September 2014 10:20 «»
By: sucheta
Re: Help with pre 9i Join to ANSI standard
…is my ANSI attempt and attempt to get it to the correct formatting, syntax, etc for all here to view. I see what everyone means about the + now. My mistake obviously. Apologies. Yes table_t3.alternateid is nullable.
SELECT table_t2.username…
|
| 12 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 September 2014 09:35 «»
By: sucheta
Re: Help with pre 9i Join to ANSI standard
…it is formatted. Looks worse to me but if others can read it better, so be it.
SELECT table_t2.username,
table_t1.date,
table_t1.days,
table_t1.loginid
FROM table_t1,
table_t2,
table_t3,
…
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 September 2014 09:22 «»
By: sucheta
Help with pre 9i Join to ANSI standard
…have been tasked with converting old style join to ANSI. I completed the task but the two queries return slightly different result sets. It seems I have done something incorrect and hope someone can show me the proper conversion? Thanks
Here is the …
|
| 14 |
Forum: Reports & Discoverer «»
Posted on: Sat, 27 September 2014 12:44 «»
By: shahzad-ul-hasan
Re: detail and summary report
…HOST('RWRUN60 MODULE=REPORT_PATH\REPORT_NAME USERID=USERNAME/PASSWORD OTHER_PARAMETERS...');
See one example below.
For mentioning username and password:
Actually while calling the report through command line it will ask for the user id and password…
|
| 15 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 13 June 2014 08:42 «»
By: somnathsikdar
Delete statement is taking long time. Please suggest.
…all,
Please find the below script. I have written the script. At the end of the script a delete statement is taking 45 minute to delete 21613600 records from a table. Can you please suggest how can I improve the performance…
|
| 16 |
Forum: General «»
Posted on: Mon, 31 March 2014 00:34 «»
By: kesavansundaram
Re: How to view current date audit records from DBA_AUDIT_TRAIL
…you Mike and every one who worked for me.
below works well for me now.
col "DBMS" for a15
col "Host Name" for a30
col "OS UserID" for a15
col "User Machine" for a18
col "Time(G)" for a36
col &…
|
| 17 |
Forum: General «»
Posted on: Sun, 30 March 2014 22:56 «»
By: BlackSwan
Re: How to view current date audit records from DBA_AUDIT_TRAIL
…
1* select to_char(logged,'YYYY-MM-DD') from SYSMAN.MGMT_JOB_STATE_CHANGES
SQL> /
TO_CHAR(LO
----------
2013-07-11
2013-07-12
2013-07-12
2013-07-12
2013-07-12
2013-07-11
2013-07-12
2013-07-12
2013-07-11
9 rows selected.
SQL>…
|
| 18 |
Forum: General «»
Posted on: Sun, 30 March 2014 22:52 «»
By: BlackSwan
Re: How to view current date audit records from DBA_AUDIT_TRAIL
…
select D.NAME "DBMS",
I.HOST_NAME "Host Name",
A.OS_USERNAME "OS UserID",
A.USERHOST "User Machine",
A.TIMESTAMP "Local Time",
A.EXTENDED_TIMESTAMP "Time(G)"…
|
| 19 |
Forum: General «»
Posted on: Sun, 30 March 2014 21:20 «»
By: kesavansundaram
How to view current date audit records from DBA_AUDIT_TRAIL
…Team,
How to view current date audit records from DBA_AUDIT_TRAIL ?
21:51:32 SQL> select to_char(sysdate,'Day dd-mon-yyyy:hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'DAYDD-MON-YYYY:HH24:MI:SS…
|
| 20 |
Forum: Forms «»
Posted on: Mon, 25 November 2013 00:00 «»
By: jyothilekshmir2006
Re: Hiding hostname, username and password in URL (10g)
GO TO CONFIGURATION FILE 'reports/conf/cgicmd.dat' . then create a variable like this
rep: userid=username/password@database %* then use this rep instead of username/pass@db in your url
THANKS
JYOTHI
|
| 21 |
Forum: Weblogic & Application Server «»
Posted on: Sat, 08 June 2013 02:37 «»
By: ranamirfan
Re: How to encrypte the form, report calling addresses Or hide the address
…Dear,
1- Set your REPORTS_PATH in Registry
D:\10gpayroll\reports;
2- Define your UserName & Password / Report Server Name / Desformat & destype in Your cgicmd.dat file.
usr: userid=PR/CAAPR2013@hpdb Server=…
|
| 22 |
Forum: Weblogic & Application Server «»
Posted on: Fri, 24 May 2013 02:16 «»
By: annu-agi
How to encrypte the form, report calling addresses Or hide the address
…all gurus and experts
I have a application developed and running on WLS server and Oracle Application server 10g. The development is on forms and report 10g and 11g as well. All are running fine, now i would like to encrypt the address calling from …
|
| 23 |
Forum: Backup & Recovery «»
Posted on: Fri, 17 May 2013 10:04 «»
By: nmd_group
database backup problem on 10G
…first i run the following script as sysdba to maintain character set
-----------------------------------------------------------------------
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET …
|
| 24 |
Forum: Server Administration «»
Posted on: Tue, 26 March 2013 18:01 «»
By: alan.kendall@nfl.com
Re: Comparing DB parameters
…have one that does it in one swoop.
ECSCDAS1S > @vp_sp_dblink
Enter value for remote_tns: cscdap1p
Enter value for local_tns: cscdas1s
Table ALAN_REMOTE created.
270 rows selected from ecscdap1p@cscdap1p.
270 rows inserted into …
|
| 25 |
Forum: General «»
Posted on: Sun, 24 March 2013 09:32 «»
By: Michel Cadot
Re: reading from AUD$ Tables causes the performance issue ?
…is correct I didn't check the view definition (I should). The best option is to directly query SYS.AUD$ and not DBA_AUDIT_TRAIL and add an index on SYS.AUD$.NTIMESTAMP# as TIMESTAMP# is no more used.
Don't forget the WITH part of my query:
ith …
|
| 26 |
Forum: Networking and Gateways «»
Posted on: Tue, 05 March 2013 07:59 «»
By: sakamboh
Re: ORA-02047: cannot join the distributed transaction in progress
…Guys i have resolved the issue but their is a drawback of this solution... can anyone help me with this... I have modified my triger and now its working fine... but if i rollback in oracle it doesnot rollback in SQL. Please check below.
create or …
|
| 27 |
Forum: Networking and Gateways «»
Posted on: Tue, 05 March 2013 07:15 «»
By: sakamboh
ORA-02047: cannot join the distributed transaction in progress
…All,
I am trying to create dblink from oracle11GR2@linux to sql using easysoft odbc driver.
DBlink is successfull, i am able to use insert statements in SQL.
I want to insert in SQL database table whenever their is a insert in Oracle Table,I have…
|
| 28 |
Forum: Forms «»
Posted on: Wed, 05 December 2012 02:51 «»
By: Akarsh
sql loader with forms
…am using oracle forms 10g on windows 7 32 bit.
i want to load data from oracle form to oracle database.
i have written the following code on Push Buttons When-Button-Pressed trigger.
declare
usid varchar2(10):= get_application_property(username…
|
| 29 |
Forum: Server Utilities «»
Posted on: Wed, 21 November 2012 06:40 «»
By: Littlefoot
Re: Restore Dump File Error
…shouldn't guess syntax. Original export and import. Short help:
M:\>imp help=y
Import: Release 11.2.0.2.0 - Production on Sri Stu 21 13:39:55 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
You can let …
|
| 30 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 25 October 2012 03:22 «»
By: monkey_suit
Re: Converting utl_http.read_text to PDF file
…
declare
lf_file utl_file.file_type;
lr_raw_data raw(32767);
lb_clob_response clob;
lh_http_request utl_http.req;
lh_http_response utl_http.resp;
ln_counter pls_integer := 0;
ln_substr_len…
|
| 31 |
Forum: Forms «»
Posted on: Sat, 20 October 2012 03:28 «»
By: hissam78
LOGIN USER FROM ONE CANVAS AND ACCESS SECOND CANVAS AS PER USER RIGHTS
…ALL,
- we have user id parameter.
can we update the parameter(:parameter.p_userid) before firing "WHEN NEW FORM INSTANCE TRIGGER"(when new form instance trigger contain code for tree node), for login another
canvas as per user rights?
- i …
|
| 32 |
Forum: Server Utilities «»
Posted on: Wed, 05 September 2012 07:14 «»
By: Michel Cadot
Re: ORA: 31633 unable to create master table :SYS.SYS_EXPORT_SCHEMA_05"
…C:\>dbv help=y
DBVERIFY: Release 10.2.0.4.0 - Production on Mer. Sept. 5 14:13:32 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Keyword Description (Default…
|
| 33 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 13 August 2012 03:02 «»
By: nischalinn
Re: incrementally increasing userid value via looping
…I tried this, but got the error:
I do not know whether my approach is right or wrong. Please suggest me the right way to solve my problem.
DECLARE
CURSOR c1 IS
SELECT username FROM reg_user
FOR update;
init NUMBER(10);
lRow …
|
| 34 |
Forum: Server Utilities «»
Posted on: Sat, 11 August 2012 05:15 «»
By: oracle@learner
Re: Restore
…try to connect from Net manager , not able to connect.
Attempting to connect using userid: test1
The test did not succeed.
ORA-01017: invalid username/password; logon denied
There may be an error in the fields entered,
or the server may not be …
|
| 35 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 10 August 2012 05:15 «»
By: nischalinn
incrementally increasing userid value via looping
…I've a table
create table t1
(
USERNAME VARCHAR2(50),
PASSWORD VARCHAR2(20)
)
***
insert all
into t1(USERNAME,PASSWORD) values ('A','aa')
into t1(USERNAME,PASSWORD) values ('B1','vv')
into t1(USERNAME,PASSWORD) values ('C1','iiii')
into t1(…
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 07 August 2012 05:55 «»
By: nischalinn
updating Nth row and adding a column (merged 2)
…had created a table which have 100s' of entries in it.
create table reg_user
(
USERNAME VARCHAR2(50),
PASSWORD VARCHAR2(20)
)
***
insert all
into reg_user (USERNAME,PASSWORD) values ('A','aa')
into reg_user (USERNAME,PASSWORD) values ('B','vv')
…
|
| 37 |
Forum: Server Utilities «»
Posted on: Mon, 16 July 2012 19:45 «»
By: alan.kendall@nfl.com
Re: Export Multiple tables only
…have used the following sql to generate exports with multiple tables in each export dump file. The backslash tells the Unix OS that the open parenthesis and the close parenthesis are not to parsed by the Unix OS. Also the backslash is added to each line …
|
| 38 |
Forum: Backup & Recovery «»
Posted on: Wed, 11 July 2012 01:30 «»
By: Michel Cadot
Re: Taking a dump of huge table
…classic "exp":
C:\>exp help=y
Export: Release 10.2.0.4.0 - Production on Mer. Juil. 11 08:27:45 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Export prompt you for parameters by entering the EXP
…
|
| 39 |
Forum: Security «»
Posted on: Mon, 28 May 2012 02:44 «»
By: raj9999
How to disable sql login
…to disable a user's sql login? To ellaborate, I want a user to login through a certain application only with his userid on database level & not through "sqlplus username@dbname".
Is it possible? If no, then what can be done to achieve …
|
| 40 |
Forum: Reports & Discoverer «»
Posted on: Mon, 21 May 2012 05:06 «»
By: manirocks
rwclient.sh key mapping
…Hello,
I've searched a lot of forums to know how can the username and passwords are hided when we invoke reports through rwclient.sh.
I am getting a perfect output if I issue a rwclient.sh but I am hardcoding userid parameter while issuing the …
|
Blog
Search
Help
Members
Register
Login
Home